Test Series - computer fundamental

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99

Test Number 65/95

Q: In a spreadsheet, letters are used to represent _____________
A. Cells
B. Rows
C. Columns
D. Blocks
Solution: In any spreadsheet, the letters are used to represent columns. The numbers are used to represent rows.
Q: Cells are identified by a combination of letters and numbers.
A. True
B. False
C. none
D. .
Solution: The statement is true. A combination of the row number and column letter gives us the cell address.
Q: A numeric data analysis tool that allows us to create a computerized ledger.
A. Word processing package
B. Spreadsheet package
C. Graphics package
D. Mathematical Package
Solution: A spreadsheet package is the numeric data analysis tool. It is useful for any numerical analysis problem whose data can be organized as rows and columns.
Q: Which of the following isn’t a part of a spreadsheet?
A. row number
B. column number
C. column letter
D. cell address
Solution: The answer is column number. There are no column numbers in a spreadsheet. Columns are represented using letters.
Q: Spreadsheets cannot:
A. do calculations
B. create graphics
C. plot graphs
D. plot charts
Solution: Spreadsheets are not meant to create graphics. They can do all sorts of calculations, plot charts and graphs, etc.
Q: ___________ help us to see patterns.
A. Spreadsheets
B. Calculations
C. Charts
D. Graphs
Solution: Charts in spreadsheets give us a picture of our data. It can help us to see patterns as well.
Q: An easier way to set up complicated calculations.
A. Decimals
B. Fractions
C. Booleans
D. Functions
Solution: Functions make it easier to set up complicated calculations. Various formulae can also be used.
Q: The cell that is in use.
A. Highlighted cell
B. Main cell
C. Active cell
D. Formula cell
Solution: It is called the active cell. The address of the active cell is shown in the formula bar.
Q: The placement of information within a cell at the left edge, right edge, or centered is :
A. Indentation
B. Placement
C. Identification
D. Alignment
Solution: The correct option is Alignment. The left, right and center positioning is defined by the alignment.
Q: A change in the appearance of a value or label in a cell.
A. Alteration
B. Format
C. Indentation
D. Design
Solution: Formatting is the term used whenever there are changes in the appearance of a value or label.

You Have Score    /10